JDBC Driver Download for Oracle, MySQL, SQL Server, PostgreSQL, Derby, SQLite, H2 and Microsoft Access
- Details
- Written by Nam Ha Minh
- Last Updated on 02 March 2022   |   Print Email
JDBC Driver Download:
Database | JDBC Driver Provider | JAR file name | Download |
MySQL
|
Oracle Corporation |
mysql-connector-java-VERSION.jar |
|
SQL Server
|
Microsoft Corporation |
sqljdbc41.jar, sqljdbc42.jar |
|
Oracle |
Oracle Corporation |
ojdbc6.jar, ojdbc7.jar, ojdbc8.jar |
Download JDBC Driver for Oracle (login required)
|
|
The PostgreSQL Global Development Group |
postgresql-VERSION.jar |
|
Apache Derby
|
Apache Software Foundation |
derby.jar, derbyclient.jar |
|
SQLite |
Xerial.org |
sqlite-jdbc-VERSION.jar |
Download JDBC Driver for SQLite
|
H2
|
h2database.com |
h2-VERSION.jar |
|
Microsoft Access |
UCanAccess.com |
ucanaccess-VERSION.jar |
Download JDBC Driver for Microsoft Access
|
NOTES:
- Some drivers come as JAR files (Oracle, PostgreSQL), so you can add the JAR files directly to your application’s classpath.
- Some drivers come as zipped bundles (MySQL, SQL Server), so you have to extract the bundles and copy the appropriate JAR file (as specified in the above table) to your application’s classpath.
- There is a distribution of Apache Derby comes with JDK 7 called Java DB. So if you are using JDK 7, you can use the jar files directly from JDK_HOME\db\lib directory without downloading Apache Derby. However, Java DB is removed from JDK since Java 8.
Maven Dependencies for JDBC Drivers
If your Java project uses Maven, simply add the following dependency in the pom.xmlfile.
Maven Dependency for MySQL JDBC Driver:
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.11</version> </dependency>
Maven Dependency for Microsoft JDBC driver for SQL Server:
<dependency> <groupId>com.microsoft.sqlserver</groupId> <artifactId>mssql-jdbc</artifactId> <version>8.2.1.jre11</version> </dependency>
Maven Dependency for Oracle JDBC Driver:
<dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc8</artifactId> <version>1.0</version> <scope>system</scope> <systemPath>d:/Path/To/Oracle/ojdbc8-full/ojdbc8.jar</systemPath> </dependency>NOTE: Due to Oracle's license restriction, you must manually download Oracle JDBC driver and use system dependency like that.
Maven Dependency for PostgreSQL JDBC Driver:
<dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifactId> <version>42.2.2.jre7</version> </dependency>
Maven Dependency for SQLite JDBC Driver:
<dependency> <groupId>org.xerial</groupId> <artifactId>sqlite-jdbc</artifactId> <version>3.21.0.1</version> </dependency>
Maven Dependency for Apache Derby JDBC Driver:
<dependency> <groupId>org.apache.derby</groupId> <artifactId>derby</artifactId> <version>10.14.2.0</version> </dependency>
Maven Dependency for H2 JDBC Driver:
<dependency> <groupId>com.h2database</groupId> <artifactId>h2</artifactId> <version>2.1.210</version> </dependency>
Maven Dependency for Microsoft Access JDBC Driver:
<dependency> <groupId>net.sf.ucanaccess</groupId> <artifactId>ucanaccess</artifactId> <version>4.0.4</version> </dependency>NOTE: The versions of the dependencies listed above may not be up to date. You can search on Maven Central Repository for the latest versions.
Related JDBC Tutorials:
- JDBC Database Connection URLs
- How to connect to a database with JDBC
- JDBC CRUD Tutorial
- JDBC Transaction Tutorial
- How to call stored procedure with JDBC
- How to read database metadata in JDBC
- How to insert binary data into database with JDBC
- How to read binary data from database with JDBC
- How to use Scrollable ResultSet
- How to use Updatable ResultSet
- How to use CachedRowSet
Comments
Muchas Gracias.
oracle site for we is blocked .... ( i from iran) ...
please send me oracle JDBC driver library to my email :
mortezahashemihkgmail.com
tnx